Release 10.1A: OpenEdge Data Management:
Database Administration

Base Index (-baseindex)

Operating system and syntax	UNIX Windows	-baseindex n
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
DBS	–	–	–	–

n

The starting index number in the range of indexes for which you want to track access statistics.

Use Base Index (-baseindex) with Index Range Size (-indexrangesize) to specify the range of indexes for which you want to collect statistics. Access to the statistics is handled through the Virtual System Tables (VSTs). Index statistics are stored in the _IndexStat VST. To obtain index numbers, use the following 4GL code:

FOR EACH _file:      DISPLAY _file._file-name.      FOR EACH _index WHERE _index._file-recid = RECID(_file):            DISPLAY _idx-num _index-name.      END. END.

This results in the following output:

File-Name filename _idx-num Index-Name      n1 index name1      n2 index name2      n3 index name3